Open topic with navigation

Creating Oracle datasheets

If you have a large amount of existing test data in an Oracle database, you can create an external datasheet to use it in data-driven scripts. You can retrieve all data from a table, use a query to retrieve a subset of data, or use a script-generated query to retrieve data during playback.

Note: Oracle 8i release 3 and later databases are supported.

1. Choose Data > Create Datasheet.

The Create Datasheet wizard opens.

2. Select an external data source option.

• Import data from external source imports data from the source and maintains it in QA Wizard Pro. Any changes to the imported data in the datasheet are not synced with the source.
• Link to data in external source links the datasheet to the source. Any changes to the data in the QA Wizard Pro datasheet are synced with the source and vice versa.

3. Click Next.

4. Select Oracle database as the Datasheet type.

5. Select a database connection type and enter the connection details.

• TNS alias connection uses a TNS alias to connect to the database.
• Basic connection uses the specified Oracle Server address and Server port. The default port is 1521. Select a database connection option and enter the SID/Service name. Connect via SID connects to the database using a system identifier. Connect via Service Name connects to the database using the service name.

6. Select an Authentication type.

• Use integrated security uses the built-in Oracle authentication to access the database.
• Use specified user and password uses a specific username and password to access the database. Enter the User and Password.

7. Select a Source to use to retrieve data from the database.

• Table retrieves all data from the specified table.
• Query uses the specified query to retrieve a subset of data from a database table. The query must return data from the source database to populate the datasheet. See Retrieving external data with database queries.
• Script-generated query uses a function in a script to retrieve a subset of data during playback. This option is only available if the datasheet links to an external data source. If this option is selected, you cannot view or edit the datasheet in QA Wizard Pro or modify the data source using scripts. See Retrieving external data with script-generated queries.

8. Click Next.

9. Specify the datasheet properties.

• If you are importing data, click Browse to select the Datasheet path to save the file in and enter a File name. Datasheets are saved with a .qawsheet extension. You can also enter an optional Description for the datasheet.
• If you are linking to the external data source, enter a Datasheet name.

10. Click Finish to add the datasheet to the workspace.